2014-10-28 - 15373 - Enhancement - Add Intercompany customers to exclusions #BExQueriesforCrystalReportsAnalysisTool
ENHANCEMENT
15373 - Add Intercompany customers to exclusions
Requirement Summary
Need to exclude the following list of new intercompany customers from all BEx queries:
eCommerce
1017051 EC-BOOKING
1017052 EC-CASH ON DELIVERY
1017053 EC-PREPAID
Retail
1017059 NEW ERA ODAIBA
1017060 NEW ERA OSAKA
1017061 Pop-Up Store
1017062 Retail Tokyo Shop
1017057 ニューエラアウトレット入間 (NEW ERA OUTLET IRUMA)
1017058 ニューエラアウトレット酒々井 (NEW ERA OUTLET SHISUI).
Admin Info
Purpose
|
Need to exclude the above list of customers from all BEx queries.
|
Requested By
|
Matthew Reeves
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
10-28-2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
BEx Queries & Intercompany Customers attached.
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
12
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Transports
|
04
|
|
TOTAL
|
24
|
References
Prior Tickets
None
Documents
BEx Queries list.xls
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to exclude the following list of new intercompany customers from all queries:
eCommerce
1017051 EC-BOOKING
1017052 EC-CASH ON DELIVERY
1017053 EC-PREPAID
Retail
1017059 NEW ERA ODAIBA
1017060 NEW ERA OSAKA
1017061 Pop-Up Store
1017062 Retail Tokyo Shop
1017057 ニューエラアウトレット入間 (NEW ERA OUTLET IRUMA)
1017058 ニューエラアウトレット酒々井 (NEW ERA OUTLET SHISUI).
In Scope:
Need to exclude new Intercompany Customers 1017051, 1017052, 1017053, 1017059, 1017060, 1017061, 1017062, 1017057 & 1017058 from all the BEx queries in BPD(BW 7.3 Development) and transport the requests to BPQ & BPP.
Out of Scope:
All BEx queries not listed.
Solution Summary
1. Create an open BEx transport request in BPD.
2. Exclude new Intercompany Customers for 0CUSTOMER (or) 0SOLD_TO infoobjects in the BEx filter section.
3. Collect all the queries for an infoprovider into the one open transport request.
4. Transport it to BPQ for testing and move it to BPP after successful testing.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check whether the changes are collected into the transport request.
|
All the changes should be collected into the transport Rrquest.
|
2
|
Check if all the Intercompany Customers(53) are excluded in BEx queries.
|
All Intercompany customers(53) should be excluded in BEx queries.
|
3
|
Check if all the changes meet the BEx QA Standards as per checklist.
|
BEx Query should pass all the QA test cases as in checklist.
|
Solution Details
1. Create an Open transport request in BPD(BW 7.3 Development).
2. Exclude new Intercompany Customers 1017051, 1017052, 1017053, 1017059, 1017060, 1017061, 1017062, 1017057 & 1017058 for 0CUSTOMER (or) 0SOLD_TO infoobject in the BEx filter section.
3. Collect all the queries for an infoprovider into the open transport request.
4. Transport it to BPQ(BW 7.3 Quality) for testing and move it to BPP(BW 7.3 Production) after successful testing.
Issues
Some of the BEx queries need the intercompany customers to be included as specified in the attached spreadsheet.